Previous Topic

Next Topic

Configuring the global maximum number of rows returned by queries

When you install or upgrade iMIS Server .NET, IQA is configured for a default of 500 maximum rows returned by all queries. You must edit the iMIS Server .NET web.config file to change this global default to a different value.

To configure the global maximum number of rows returned by queries

  1. On your iMIS Server .NET host, open the web.config file. (The default location is C:\Program Files\IMIS.NET\web.config.)
  2. Scroll down to the <SystemParams> section and locate the following line:
    <add key="PagedResults.MaxRecords" value="500" />
  3. Change the value from 500 to your desired number of maximum rows returned by queries.
  4. Save the web.config file.

    Note: You do not need to restart iMIS Server .NET for the new default to take effect.

See Also

Query Definition

Process overview

Tips for defining queries

Advanced mode options for sources

Creating or editing a query

Limiting the rows returned by a query


ASI logo 10.6 Production Release. Updated 7/27/2006 3:52:53 PM
© 2009 by Advanced Solutions International, Inc. All rights reserved.